The UniLearn registry receives four maintenance requests. The goal is to change the intended data without affecting any other rows.
The Four Requests
- Add S106, Faisal Khan as DSAI, year 1, active, using the supplied email.
- Change only S103's email.
- Standardise Data Science to DSAI.
- Remove the incorrect test record S999.
The Safety Question
For every request, identify the operation, exact target, before and after state, and expected affected row count.
💡 Teaching Focus
A correct statement changes only the intended state.